| Employer |
| EntityType | Independent |
| Logical Entity Name | Employer |
| Default Table Name | PlEmployer |
| Logical Only | NO |
| Owner | dbo |
| Definition | |
| Note |
| Employer Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
EmployerId |
INTEGER | NO | ||
| Name | VARCHAR(40) | NO | ||
| Code | CHAR(16) | NO | ||
| StreetAddress | VARCHAR(255) | NO | ||
| City | VARCHAR(35) | NO | ||
| State | CHAR(2) | NO | ||
| PostalCode | CHAR(10) | NO | ||
| CountyId | INTEGER | YES | ||
| PhoneNumber | CHAR(16) | NO | ||
| EmailAddress | VARCHAR(60) | YES | ||
| EmployerType | CHAR(1) | YES | ||
| CampusGroupId | INTEGER | NO | ||
PlCorporateID |
INTEGER | YES | ||
| FeeAmount | CHAR(1) | YES | ||
| FeeDescription | VARCHAR(50) | YES | ||
| Note | TEXT | YES | ||
| IsActive | BIT | NO | ||
| LastModifiedUserId | INTEGER | NO | ||
| CreatedDateTime | DATETIME | NO | ||
| LastModifiedDateTime | DATETIME | NO | ||
| RowVersion | TIMESTAMP/DATE | NO | ||
| ExternType | CHAR(1) | YES | ||
| PIN | SMALLINT | YES | ||
| Faxnumber | CHAR(16) | NO | ||
| URL | CHAR(100) | YES | ||
| PhoneExtension | CHAR(5) | YES | ||
| CountryId | INTEGER | YES | ||
StaffId |
INTEGER | YES | ||
| IsValidated | BIT | NO | ||
PlacementAdvisorId |
INTEGER | YES | ||
| PracticumSite | BIT | NO | ||
| IsExcludedCrmIntegration | BIT | NO | ||
PrimaryEmployerLocationId |
INTEGER | YES | ||
OrganizationId |
INTEGER | YES | ||
IndustryId |
INTEGER | YES | ||
JobLocationId |
INTEGER | YES |
| Employer Keys |
| Key Name | Key Type | Keys |
| Nk_PlEmployer_SyNexusOrganizationId | Inversion Entry | OrganizationId |
| PlEmployer_plEmployerId_email_U_N_IDX | Alternate Key | EmployerId, EmailAddress |
| PlEmployer_Code_U_N_IDX | Unique Constraint | Code |
| PlEmployer_SyCountyID_N_N_IDX | Inversion Entry | CountyId |
| PlEmployer_SyCampusGrpID_N_N_IDX | Inversion Entry | CampusGroupId |
| Nk_PlEmployerPrimaryPlEmployerLocationID | Inversion Entry | PrimaryEmployerLocationId |
| PlEmployer_SyStaffID_N_N_IDX | Inversion Entry | StaffId |
| PlEmployer_PLAdvisorID_N_N_IDX | Inversion Entry | PlacementAdvisorId |
| PlEmployer_PlEmployerID_U_C_IDX | PrimaryKey | EmployerId |
| PlEmployer_PlCorporateID_N_N_IDX | Inversion Entry | PlCorporateID |
| Employer Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| Staff | Non-Identifying | Zero or One to Zero or More | StaffId | NO | |||
| Corporation | Non-Identifying | Zero or One to Zero or More | PlCorporateID | NO | |||
| Staff | Non-Identifying | Zero or One to Zero or More | PlacementAdvisorId | NO | |||
| Organization | Non-Identifying | Zero or One to Zero or More | OrganizationId | NO | |||
| Staff | Non-Identifying | Zero or One to Zero or More | StaffId | NO | |||
| JobLocation | Non-Identifying | Zero or One to Zero or More | PrimaryEmployerLocationId | NO | |||
| Industry | Non-Identifying | Zero or One to Zero or More | IndustryId | NO | |||
| Organization | Non-Identifying | Zero or One to Zero or More | OrganizationId | NO | |||
| JobLocation | Non-Identifying | Zero or One to Zero or More | JobLocationId | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| SevisStudent | Non-Identifying | One To Zero or More | NO | ||||
| EmployerCareerField | Non-Identifying | One To Zero or More | NO | ||||
| EmployerContact | Non-Identifying | One To Zero or More | NO | ||||
| EmployerContactAttribute | Non-Identifying | One To Zero or More | NO | ||||
| EmployerContactDataChange | Non-Identifying | One To Zero or More | NO | ||||
| EmployerContactDeletedRecord | Non-Identifying | One To Zero or More | NO | ||||
| EmployerContactJobSkill | Non-Identifying | One To Zero or More | NO | ||||
| EmployerContactSoftSkill | Non-Identifying | One To Zero or More | NO | ||||
| EmployerDataChange | Non-Identifying | One To Zero or More | NO | ||||
| EmployerJob | Non-Identifying | One To Zero or More | NO | ||||
| EmployerJobDataChange | Non-Identifying | One To Zero or More | NO | ||||
| EmployerJobDeletedRecord | Non-Identifying | One To Zero or More | NO | ||||
| EmployerJobSkill | Non-Identifying | One To Zero or More | NO | ||||
| EmployerLocation | Non-Identifying | One To Zero or More | NO | ||||
| EmployerSoftSkill | Non-Identifying | One To Zero or More | NO | ||||
| Student | Non-Identifying | One To Zero or More | NO | ||||
| StudentPlacement | Non-Identifying | One To Zero or More | NO | ||||
| StudentPlacementDataChange | Non-Identifying | One To Zero or More | NO | ||||
| StudentPlacementDeletedRecord | Non-Identifying | One To Zero or More | NO | ||||
| Task | Non-Identifying | One To Zero or More | NO | ||||
| TaskArchive | Non-Identifying | One To Zero or More | NO | ||||
| EmployerCareerField | Identifying | One To Zero or More | NO | ||||
| EmployerContact | Non-Identifying | One To Zero or More | NO | ||||
| EmployerContactAttribute | Non-Identifying | One To Zero or More | NO | ||||
| EmployerContactJobSkill | Identifying | One To Zero or More | NO | ||||
| EmployerContactSoftSkill | Identifying | One To Zero or More | NO | ||||
| plEmployerExternalMap | Non-Identifying | One To Zero or More | NO | ||||
| EmployerJob | Non-Identifying | One To Zero or More | NO | ||||
| EmployerJobSkill | Non-Identifying | One To Zero or More | NO | ||||
| EmployerLocation | Non-Identifying | One To Zero or More | NO | ||||
| EmployerSoftSkill | Identifying | One To Zero or More | NO | ||||
| PlStudentContactHistory | Non-Identifying | One To Zero or More | NO | ||||
| StudentPlacement | Non-Identifying | One To Zero or More | NO | ||||
| SyEmpGrp | Non-Identifying | One To Zero or More | NO | ||||
| SyRecentEmployer | Non-Identifying | One To Zero or More | NO | ||||
| SevisStudent | Non-Identifying | One To Zero or More | NO | ||||
| SevisStudent | Non-Identifying | One To Zero or More | NO | ||||
| SevisStudent | Non-Identifying | One To Zero or More | NO |
| Employer Check Constraints |
| Check Constraint Name | CheckConstraint |
| Employer Where Used - Model Usage |
| Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
| Logical dbo.Employer |
NO | |||
| Physical (Microsoft SQL Server) dbo.PlEmployer |
NO |
| Employer Where Used - Submodel Usage |
| Model | Submodel Usage |
| Logical | Main Model |
| Logical | AvailableJobs |
| Logical | Employers |
| Logical | SEVIS |
| Logical | StudentJobPlacement |
| Logical | Tasks |
| Physical (Microsoft SQL Server) | Main Model |
| Physical (Microsoft SQL Server) | Placement |
| Employer Data Movement Rules |
| Name | Type | Rule Text/Value |